﻿CREATE TABLE [dbo].[SiteICP] (
    [id]            INT            IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [CompanyId]     INT            NULL,
    [SId]           INT            NULL,
    [StateId]       INT            CONSTRAINT [DF_SiteICP_StateId] DEFAULT (1) NULL,
    [CustomerId]    NVARCHAR (50)  NULL,
    [CustomerName]  NVARCHAR (50)  NULL,
    [XingZhi]       NVARCHAR (50)  NULL,
    [ZhengJian]     NVARCHAR (50)  NULL,
    [Faren]         NVARCHAR (50)  NULL,
    [ShengFen]      NVARCHAR (50)  NULL,
    [City]          NVARCHAR (50)  NULL,
    [Address]       NVARCHAR (100) NULL,
    [FZR_Name]      NVARCHAR (50)  NULL,
    [FZR_Sex]       NVARCHAR (50)  NULL,
    [FZR_ZhengJian] NVARCHAR (50)  NULL,
    [FZR_Tel]       NVARCHAR (50)  NULL,
    [FZR_Fax]       NVARCHAR (50)  NULL,
    [FZR_Mobile]    NVARCHAR (50)  NULL,
    [FZR_Email]     NVARCHAR (50)  NULL,
    [WebName]       NVARCHAR (50)  NULL,
    [WebAddress]    NVARCHAR (50)  NULL,
    [KongJian_Size] NVARCHAR (10)  NULL,
    [KongJian_Year] NVARCHAR (50)  NULL,
    [KongJian_End]  DATETIME       NULL,
    [ICP_num]       NVARCHAR (20)  NULL,
    [Sales]         NVARCHAR (20)  NULL,
    [UpTime]        DATETIME       NULL,
    CONSTRAINT [PK_SiteICP] PRIMARY KEY CLUSTERED ([id] ASC)
);

